Executive Summary

R1

Last Update

2022-08-20 13:41:50

Total Sales

$2,261,537

Total Orders

9,800

Average Sales per Order

$231

R1

Product Type

Product Sales

R1

Best Sellers

Furniture

R2

Sales Analysis (2015 - 2018)

Furniture

Total Sales

$728,658.6

Proportion of Grand Total Sales

2015 Total Sales

$156,478

2016 Total Sales

$164,054

2017 Total Sales

$195,813

2018 Total Sales

$212,313

R2 {data-height = 350}

Daily Sales

Daily Sales (Log)

Monthly Sales

R2 {data-height = 650}

Difference Plot

Seasonal Plot

Subseries Plot

Furniture Forecast {data-orientation=columns}

ETS Forecast of Next 24 Months

Model Summary


Forecast method: ETS(M,N,M)

Model Information:
ETS(M,N,M) 

Call:
 ets(y = furni.ts) 

  Smoothing parameters:
    alpha = 0.1285 
    gamma = 1e-04 

  Initial states:
    l = 14423.7702 
    s = 1.9561 1.8814 0.8823 1.6921 0.7104 0.834
           0.8305 0.8466 0.709 0.7855 0.3 0.5721

  sigma:  0.2949

      AIC      AICc       BIC 
 988.0957 1003.0957 1016.1637 

Error measures:
                   ME     RMSE     MAE       MPE     MAPE      MASE       ACF1
Training set 734.9213 3049.649 2534.17 -2.732487 21.12099 0.6876885 -0.1613837

Forecasts:
         Point Forecast     Lo 95     Hi 95
Jan 2019      10207.425  4307.867 16106.983
Feb 2019       5353.166  2231.588  8474.745
Mar 2019      14014.336  5770.408 22258.265
Apr 2019      12649.974  5144.303 20155.644
May 2019      15105.678  6066.680 24144.676
Jun 2019      14817.456  5876.629 23758.283
Jul 2019      14879.544  5827.155 23931.934
Aug 2019      12675.272  4901.215 20449.329
Sep 2019      30191.470 11525.935 48857.005
Oct 2019      15742.182  5932.900 25551.464
Nov 2019      33568.911 12488.574 54649.248
Dec 2019      34900.392 12815.672 56985.112
Jan 2020      10207.437  3699.259 16715.615
Feb 2020       5353.173  1914.540  8791.805
Mar 2020      14014.352  4945.833 23082.872
Apr 2020      12649.988  4404.798 20895.179
May 2020      15105.695  5189.206 25022.185
Jun 2020      14817.473  5021.251 24613.694
Jul 2020      14879.562  4973.446 24785.677
Aug 2020      12675.286  4178.349 21172.224
Sep 2020      30191.505  9814.311 50568.698
Oct 2020      15742.200  5045.632 26438.768
Nov 2020      33568.950 10607.378 56530.521
Dec 2020      34900.432 10870.878 58929.986

Model Diagnostic


    Ljung-Box test

data:  Residuals from ETS(M,N,M)
Q* = 31.017, df = 3, p-value = 8.431e-07

Model df: 14.   Total lags used: 17

Map

R3

Overall Sales

R3

Furniture sales

Office Supplies sales

Technology sales

Raw Data

Pivot Table